SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001315s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1021683 LIMIT 1 [ RunTime:0.000420s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1021683 [ RunTime:0.001771s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (579106,695178,303450,651974,649176,107420,137988,621947,719126,801556,74717,388869,869926,846354,362218,780198,95945,348735,880382,66606,259625,25251,289883,55531,751612,47792,825490,277463,779778,114098,455706,745423,123067,800525,898889,796025,790300,856431,542668,1036742,89515,405717,458349,536650,230544,247103,241414,386749,293831,359100,834151,783893,203281,346677,666247,174600,808885,905850,845039,418993) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001074s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1021683 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000407s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1021683 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000478s ]