SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001286s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 498289 LIMIT 1 [ RunTime:0.000582s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 498289 [ RunTime:0.004744s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (478832,19158,301180,715301,416514,1035902,793010,24209,156289,706721,362149,996994,391769,1035669,47037,1035264,489914,66738,833565,182484,931500,449570,882624,918356,432496,509953,1041405,565685,629927,4430,579019,668349,239061,903442,555920,353250,208832,483392,81482,654566,606790,229054,38182,624736,587473,1024377,660450,937173,391985,993284,575360,535330,427443,609039,235297,386848,689354,14472,953612,918057) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001313s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 498289 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000458s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 498289 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000508s ]