SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001104s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 571438 LIMIT 1 [ RunTime:0.000373s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 571438 [ RunTime:0.003151s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (486748,835546,648598,333457,638705,425116,733999,958863,495209,477222,1016170,586621,321333,272316,801572,903621,244987,195500,1033736,1006657,506864,444180,43569,710255,593218,366105,4671,1005425,410964,949978,1014171,1023267,985340,691336,869545,332705,616890,177946,891007,784053,759204,80324,891427,635381,558966,489453,970359,695965,721450,1007137,445203,261958,873974,868123,110489,344751,577922,413772,708016,957857) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001110s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 571438 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000370s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 571438 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000583s ]