SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001370s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 132103 LIMIT 1 [ RunTime:0.000408s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 132103 [ RunTime:0.001524s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (353630,363650,128831,747984,930844,467502,74257,555509,659033,828595,625547,640163,443021,981515,592611,114198,877711,1018576,975159,944760,836357,213760,702649,791600,624594,24222,568197,7863,358559,870017,51021,916725,399589,811875,141474,519796,922993,1045248,292875,180308,837733,818969,391126,197475,187257,416499,915010,448536,990287,129058,1044221,233939,904858,664945,226330,862355,181181,317834,166990,2291) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.007070s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 132103 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000439s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 132103 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000963s ]