SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001160s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 426518 LIMIT 1 [ RunTime:0.000590s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 426518 [ RunTime:0.001834s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (270465,276969,5037,736128,678443,65532,515752,134933,1001525,328758,580972,642415,536492,223497,98061,70387,578348,1015958,942978,21439,571833,961368,537320,815522,48043,990984,454512,469296,584532,405618,979063,672372,759150,545438,1008959,17061,62699,70471,906735,744113,815501,652139,660897,523579,242920,707903,140829,383628,720804,844933,760916,406156,33860,984504,550698,293405,457115,73213,581244,603485) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001027s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 426518 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000379s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 426518 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000374s ]