SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001329s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 502475 LIMIT 1 [ RunTime:0.000337s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 502475 [ RunTime:0.002003s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (506803,587686,688763,924873,51687,230294,876835,913698,697271,448580,318859,617612,195846,74704,883588,449762,290703,976973,324621,1041017,104400,1026144,822882,992469,644750,347533,616973,386873,557439,912075,72685,107613,154284,226835,639653,251697,544187,826872,590429,979676,136115,885289,687961,812294,116779,94907,675044,358795,311807,540221,216921,133855,980608,518087,987316,647885,466700,923731,63602,508919) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001109s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 502475 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000373s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 502475 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000582s ]