SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001628s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 316513 LIMIT 1 [ RunTime:0.000473s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 316513 [ RunTime:0.002174s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (646377,1005578,49766,197359,117212,3462,270736,230866,552986,258160,264911,392059,837768,144644,822061,127644,877630,315713,165179,895854,602709,280234,945610,787895,577199,40763,545948,510392,937173,994026,753874,923914,44221,691470,869852,154279,544677,555577,230825,158883,555225,424249,196867,640524,415806,103775,761259,1045392,984950,792135,352889,667733,952478,130116,134136,843484,909904,804771,736017,558373) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001168s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 316513 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000476s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 316513 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000643s ]