SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001182s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 586313 LIMIT 1 [ RunTime:0.000371s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 586313 [ RunTime:0.002630s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (632439,659510,369572,537853,375257,555703,128834,311940,407962,50877,800598,251570,615067,484663,330217,696381,169844,276131,881687,1024189,148999,817666,89153,236263,778961,160179,505684,138348,725237,918878,226884,528759,635098,192882,874886,874083,819769,540412,142130,485416,44143,857417,379755,20959,856437,4734,812402,551898,200135,761657,2392,513084,263950,310866,381639,929326,965302,459952,153405,154805) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001282s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 586313 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000423s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 586313 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000614s ]