SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001278s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 447290 LIMIT 1 [ RunTime:0.000405s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 447290 [ RunTime:0.003059s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (704261,1042551,78701,402764,932809,102837,229613,947835,407833,70823,621025,364169,379365,170969,626418,159265,1039814,531258,915742,604856,594368,1021727,890196,459677,52724,631147,932187,279398,119030,703667,33324,349999,298680,62537,861888,690204,313275,338636,671778,78959,289886,16541,968181,296913,992230,497043,1011543,812761,202025,351509,294897,533715,1018364,804110,378322,881374,341976,1008383,730384,223913) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001280s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 447290 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000438s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 447290 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000551s ]