SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001351s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 298316 LIMIT 1 [ RunTime:0.000373s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 298316 [ RunTime:0.001564s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (567819,14613,653465,287613,185244,372467,51245,953442,44795,275892,1009045,450116,1008784,505073,730950,708574,256626,569269,225867,352524,277969,706573,553757,362199,216527,489838,108551,721574,292675,804223,438667,288585,131106,294161,827149,711581,987699,522141,117999,832096,867433,779785,150479,497322,907766,892730,538932,614250,213903,28965,261313,651177,358293,148008,704889,90427,1021388,136572,657166,173799) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000951s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 298316 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000379s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 298316 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000499s ]