SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001342s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 502007 LIMIT 1 [ RunTime:0.000315s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 502007 [ RunTime:0.002453s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (357304,498702,109924,808973,52350,554131,440211,647447,901932,969724,4636,644166,164330,427161,138617,440974,811477,681004,402247,363881,244229,457097,420953,594098,1028852,138231,327662,610578,426900,598349,863764,163553,914159,999032,161250,67030,960571,788580,590974,1029181,569382,725442,871106,977884,85162,30853,571239,359848,399421,327210,348200,215781,185695,691913,689295,102235,73430,961153,474152,589272) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001311s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 502007 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000575s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 502007 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000461s ]