SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001386s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 538170 LIMIT 1 [ RunTime:0.000395s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 538170 [ RunTime:0.001762s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (509179,891389,142381,562333,388748,414415,147149,942176,139354,372140,73727,145862,173031,1019708,297141,603997,629404,264454,501242,579135,640883,1017812,513176,613313,851889,490028,528498,149955,778952,84616,575400,79740,321179,423163,321994,747747,455841,477722,416573,56763,96593,382251,337078,570485,795424,545534,462621,719110,251439,384518,641870,562431,43222,573147,566458,980508,242677,695767,331531,32643) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.004276s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 538170 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000396s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 538170 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000610s ]