SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001106s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 803105 LIMIT 1 [ RunTime:0.000358s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 803105 [ RunTime:0.001581s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (580570,558765,439614,940611,594181,188790,493616,516770,334398,199304,90839,41903,745417,200751,649881,4517,183113,381832,681428,425067,781761,262242,134771,42939,61735,166413,8423,552347,246709,147484,790086,255758,526814,106941,762558,183545,108024,418434,180041,531660,893743,744899,17905,127740,121539,757503,499963,1004024,941309,605303,996975,394444,813165,260093,491780,921242,138851,577193,387705,520117) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001562s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 803105 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000490s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 803105 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000603s ]