SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001149s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 564080 LIMIT 1 [ RunTime:0.000456s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 564080 [ RunTime:0.001807s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (749653,400056,599419,445165,458017,643854,372655,109905,290543,44360,413898,771009,1027690,442596,660498,216935,374326,576065,180742,890285,19993,640290,622599,794336,938048,796116,321428,995139,516140,403673,403132,860423,415870,63562,1011342,368145,804774,832939,445230,974591,773956,834331,1047606,1047052,883461,693136,233970,200237,527778,635268,54518,559223,179363,386904,128948,143163,719069,1000850,800656,968109) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001125s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 564080 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000386s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 564080 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000398s ]