SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001225s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 689741 LIMIT 1 [ RunTime:0.002729s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 689741 [ RunTime:0.004402s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1028702,38761,774452,990846,295417,196077,518335,622692,224255,276350,231515,47047,421385,59594,136010,202029,386982,8677,898945,317056,287543,905124,873718,35942,953748,138276,151002,831665,552924,451393,689398,1011510,877405,998917,616303,183914,522098,830144,486898,279223,1006082,1034631,709940,552887,14869,409332,162270,38179,66277,263684,300253,805297,117368,779154,611843,376234,365697,714369,836781,148823) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001370s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 689741 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000441s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 689741 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000658s ]