SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001235s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 403811 LIMIT 1 [ RunTime:0.000422s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 403811 [ RunTime:0.001898s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (956422,748388,775655,682767,7017,943051,371543,756516,759828,654652,159867,756150,9560,842714,191410,1010817,988927,905228,924541,378764,1977,760469,358821,457727,787779,339758,835572,506950,42372,685496,282584,658785,61682,453232,276992,924007,983575,425825,627051,361307,195076,14797,349472,110110,265116,542837,855520,352700,65475,254188,804812,632556,981729,78111,475572,861781,583258,338993,11122,508382) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001095s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 403811 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000499s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 403811 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000628s ]