SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001264s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 527178 LIMIT 1 [ RunTime:0.000382s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 527178 [ RunTime:0.004421s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (191455,251042,740419,782732,435526,354553,563680,130558,1000300,622923,417127,636416,266011,522585,858655,200710,353091,819698,601685,562404,926227,957563,408444,995197,720364,252110,279516,710369,919608,98783,137480,830204,659174,803105,515409,627333,524442,516635,565447,222842,160165,857335,686032,1021096,767037,398474,449299,234606,463376,983193,29756,621021,10871,507499,611634,555251,998001,397,383931,974347) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001131s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 527178 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000336s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 527178 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000570s ]