SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001137s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 42928 LIMIT 1 [ RunTime:0.000308s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 42928 [ RunTime:0.001785s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (3028,54461,836781,71896,22172,154324,299583,313960,672216,170712,166728,874970,683191,11169,599779,671546,839205,220869,715577,344873,714946,364289,495758,710973,1000245,96017,558290,36213,125256,826384,723200,341887,475155,538134,148341,61458,415519,815731,739419,796386,659990,374293,534915,802107,164185,1029263,584465,102568,272669,840752,383493,700858,170234,715394,853177,713080,86306,851411,23353,677151) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000933s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 42928 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000471s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 42928 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000767s ]