SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001116s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 108894 LIMIT 1 [ RunTime:0.000326s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 108894 [ RunTime:0.001568s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (254600,426719,38809,898863,291384,350985,783809,862886,689559,328153,215372,669874,571713,347374,1048060,990762,241452,465195,101608,207817,81870,5191,622208,179254,667659,368380,18463,745716,633476,411163,683751,315082,209448,478568,814729,530108,45870,954955,630878,819548,73075,382315,997253,178037,265332,495963,989027,837612,690501,533070,562998,2728,956864,912929,512148,69089,639122,472520,793522,1018390) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000960s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 108894 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000381s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 108894 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000544s ]