SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001284s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 318024 LIMIT 1 [ RunTime:0.000451s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 318024 [ RunTime:0.001561s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (629632,179540,244144,873583,158957,180712,122672,361601,12725,710307,634240,361774,144824,346099,212755,724776,936571,138032,777867,160138,426810,569740,888822,559954,94710,232768,353040,819889,743481,316649,115626,786724,1019387,78909,387429,8850,442129,4605,387936,259717,259314,88263,352447,1001080,293757,900634,998918,465570,921598,938004,997760,670705,148721,36487,267927,781820,237161,375949,288820,205138) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001036s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 318024 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000378s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 318024 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000511s ]