SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001131s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 428660 LIMIT 1 [ RunTime:0.000348s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 428660 [ RunTime:0.001854s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (141886,438436,980914,173582,1007539,30196,442048,169012,970546,800598,352315,227068,751494,947709,462774,380795,800069,965145,907263,142150,178921,633023,46050,425725,750938,992694,702483,628574,940760,575840,1014695,967945,95695,386398,850933,831950,270286,14760,440808,249671,811574,972182,537173,978219,869414,1025388,693116,854704,671571,370390,290909,420001,243115,11501,281882,13654,368107,967807,203394,174900) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000975s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 428660 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000333s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 428660 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000646s ]