SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001775s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 147441 LIMIT 1 [ RunTime:0.000640s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 147441 [ RunTime:0.004165s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (104858,273466,101136,346119,50601,791764,822301,296942,897037,951791,1027234,829128,31760,741522,862349,225969,837731,37539,710860,195318,906978,638155,930122,930765,227475,359327,524601,340309,269396,736260,693747,168528,597720,240090,1033924,382128,94956,653023,179239,724480,732234,127644,1021345,991629,286648,854558,525590,131908,122501,505781,54570,646547,152614,624872,20676,116433,75903,227234,423292,354431) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001219s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 147441 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000357s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 147441 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000580s ]