SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001187s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 195512 LIMIT 1 [ RunTime:0.000326s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 195512 [ RunTime:0.002176s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (339784,3776,541396,101671,274711,499245,641339,908508,638888,388760,669474,290431,255413,40851,479594,446527,292453,942673,268698,594206,354951,412705,365354,159231,574038,485462,829693,308416,75925,511060,87243,369564,673505,263895,35378,958622,615841,38570,1036991,1000945,923327,357309,2484,971978,5170,32257,285102,851610,788319,1021746,430334,404573,281449,689726,361706,613434,383209,459242,354855,362523) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001085s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 195512 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000385s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 195512 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000595s ]