SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001193s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1046195 LIMIT 1 [ RunTime:0.000321s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1046195 [ RunTime:0.001450s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (424001,795458,219656,981048,965203,702967,415344,1015913,7890,806193,794391,874070,701896,494833,917777,852301,267429,705156,375145,300113,617441,924285,196171,903164,560200,765867,13968,1042816,671089,1001385,526678,38933,171531,652867,649038,743752,113212,459897,38748,800475,545729,316232,42474,935045,273833,793788,750783,81058,1002750,666515,714348,731134,127004,190692,507732,643211,708996,93739,300329,217423) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001087s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1046195 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000403s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1046195 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000432s ]