SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001189s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 153481 LIMIT 1 [ RunTime:0.000411s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 153481 [ RunTime:0.001741s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (518479,342897,16718,395256,432451,790479,221630,184108,176418,441650,939044,1040925,504263,556725,142717,674542,147202,600984,663795,934243,1024113,439358,978080,799635,614861,425389,371018,743943,1038384,313940,76662,1018829,901284,325765,504591,950269,936600,564447,814291,598089,605873,165596,364745,949891,681883,236413,270026,883464,395160,170771,690878,602283,336515,405802,394292,203930,478450,1017675,322411,636683) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001113s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 153481 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000386s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 153481 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000724s ]