SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001193s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 405207 LIMIT 1 [ RunTime:0.000327s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 405207 [ RunTime:0.002119s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (945747,160401,34893,414590,3977,197730,786913,948554,229902,715266,379211,937482,40762,37519,515639,908622,48127,149921,275775,476701,232865,863203,166071,336180,203763,138996,682630,415887,424658,1014326,513740,217647,748788,200837,199204,614777,508275,77764,124249,817847,649558,738887,448504,436873,992072,53970,1030433,352325,1032843,290991,690203,750043,358698,17024,651975,502215,767141,917666,267518,205177) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001132s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 405207 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000448s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 405207 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000509s ]