SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001777s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 591318 LIMIT 1 [ RunTime:0.000382s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 591318 [ RunTime:0.004334s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (322705,923292,489327,1015762,651216,482090,412821,1044583,796256,534084,563635,512997,169267,691081,398579,116788,685595,50767,967574,315494,527696,724392,8760,270454,388086,170984,518463,533860,648931,941229,807846,358074,397596,789367,718482,81498,720421,494799,341230,391886,366578,75141,141775,219736,694141,977449,450074,82419,307172,504830,1045285,990689,455715,924045,383293,473977,696109,781524,366460,123047) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002467s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 591318 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000942s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 591318 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001739s ]