SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001159s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 416820 LIMIT 1 [ RunTime:0.000381s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 416820 [ RunTime:0.001655s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (410058,938416,704556,508933,71687,110033,734790,1037251,761477,140197,847470,384096,1047750,227563,628647,91288,178072,753218,1001381,627729,251274,638827,564070,129937,119972,632968,978924,166631,177460,562089,862726,81390,128197,81833,552499,129846,1009976,444092,138934,471964,384893,698224,85713,667207,163739,961016,640715,175664,651444,945432,135075,215064,566912,712257,576267,52099,949683,974743,42815,634926) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001146s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 416820 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000368s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 416820 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000694s ]