SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001303s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 560615 LIMIT 1 [ RunTime:0.000408s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 560615 [ RunTime:0.003409s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (569594,961291,834303,892462,459144,1007,956432,889090,924968,572862,436597,387097,418099,905519,974881,929141,644184,736379,5861,4061,290746,977622,400354,875885,228203,785949,875801,44084,457194,555917,471370,464540,676366,867507,907332,564042,600516,631661,554278,868765,369887,365104,852296,1882,999141,182089,111284,936469,905269,83519,767351,871934,556980,442957,132036,974455,181057,572618,690326,572017) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.007816s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 560615 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000456s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 560615 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001202s ]