SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001277s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 502005 LIMIT 1 [ RunTime:0.001367s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 502005 [ RunTime:0.003011s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (501615,1010375,565044,176809,3035,551977,64631,44244,698640,639280,618755,604752,532326,832910,967252,250029,277095,816252,29098,365886,1021863,732293,127177,987800,420650,383566,857112,277024,431535,987330,295279,949674,819736,696689,121548,655503,333307,250022,33089,954483,462539,206344,138896,478700,633023,876492,711320,484358,35604,553773,712762,593762,633286,309773,663362,689280,564961,211186,791649,369204) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001738s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 502005 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000495s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 502005 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000557s ]