SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001310s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 519522 LIMIT 1 [ RunTime:0.000348s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 519522 [ RunTime:0.003217s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (625814,140511,135376,344520,188102,334004,480857,812811,724796,1003020,528145,383509,310010,394219,1012756,19559,1028855,85437,911078,782718,85598,110534,1014356,574058,540950,899257,76169,660533,470380,49862,639660,488902,408963,321586,582810,90626,68982,754494,709685,221566,69570,329567,61746,21628,97781,258170,752623,628583,85377,980496,29837,1048164,518590,444629,1017803,561168,528561,857912,811957,139719) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001301s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 519522 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000434s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 519522 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000554s ]