SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002218s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 393701 LIMIT 1 [ RunTime:0.003674s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 393701 [ RunTime:0.001924s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1007785,544102,700229,602081,621052,400243,397889,991056,800959,862263,462057,474777,333956,820981,791890,820014,602084,1001941,470508,825179,941372,915923,752835,798815,555953,238189,803788,610828,387705,558495,778854,552641,534169,813911,855103,191835,731048,40966,481095,479242,977013,654044,614604,924843,90910,295903,13732,574708,70138,407913,353884,876255,741993,283053,1021172,321089,180833,66202,550530,376625) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001593s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 393701 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000449s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 393701 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001287s ]