SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001127s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 502760 LIMIT 1 [ RunTime:0.000293s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 502760 [ RunTime:0.001484s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (911266,824108,411848,1006714,268414,75050,573747,107909,794677,301714,423451,635297,848897,228094,624048,936154,980268,279255,988974,783410,778200,716430,159697,811592,113536,798396,912933,445824,864234,756630,476553,441995,659965,166571,973039,1046825,319843,309640,842093,293015,622655,888069,371303,207391,687734,971284,1027787,413754,1035745,151281,465160,215709,426056,973213,300218,964962,394892,642000,133465,379325) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001060s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 502760 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000379s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 502760 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000701s ]