SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.003669s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1018210 LIMIT 1 [ RunTime:0.000551s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1018210 [ RunTime:0.002459s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (89268,465011,555023,979047,657340,894772,200827,459585,983070,672407,596363,639445,25102,240113,50464,574640,251059,237710,650632,596144,628926,220487,144667,164370,991282,30986,259777,592174,479432,366493,973626,731043,201859,271812,231782,324407,285700,229446,113532,64929,973376,388659,970084,402968,604997,14236,422547,122218,30559,846258,670413,656045,312674,680289,728566,275124,424505,980587,633390,536093) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002405s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1018210 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001750s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1018210 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000594s ]