SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001119s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 406046 LIMIT 1 [ RunTime:0.000327s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 406046 [ RunTime:0.002109s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (552832,638340,532058,955781,272110,666712,458878,869305,581785,222618,855347,217818,19382,782441,160981,1010076,565861,672541,34231,331423,875715,56435,502546,622724,713611,204742,671205,898032,360027,678358,302563,787394,948465,601762,322029,441114,765339,704590,60590,261450,946774,662847,339077,575633,902250,213865,12436,507377,941092,235494,502304,248194,171959,322122,896282,379697,469079,170466,696888,943590) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001459s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 406046 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000356s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 406046 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000584s ]