SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001201s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 598043 LIMIT 1 [ RunTime:0.001197s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 598043 [ RunTime:0.002794s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (628967,400904,184074,916233,1027120,560938,118450,65118,859715,715669,693038,951884,515138,622348,1044118,708041,217319,221828,302700,963928,198270,543803,806917,76132,834146,973098,181551,33947,861457,595082,423714,625579,796606,871539,232612,891275,219699,667869,146248,307830,40720,381845,16304,174728,640132,712231,508909,746685,82199,189786,227857,575619,317692,260050,136685,780898,289472,70845,269253,368785) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.003323s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 598043 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000473s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 598043 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.002206s ]