SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001098s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 390510 LIMIT 1 [ RunTime:0.000304s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 390510 [ RunTime:0.001970s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (806746,387570,542136,82841,1024947,656456,956765,234611,1019822,512456,425204,267174,815846,630982,204345,106656,964301,153595,361677,202572,213869,607452,258416,330216,697745,408018,520523,416193,224543,579599,286740,924478,238873,271224,628153,495747,740542,987184,799141,644427,532663,1023384,235449,1033143,124449,655033,506732,516758,86983,752668,808964,1024296,568899,580484,209170,861482,845000,578115,679779,309491) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001267s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 390510 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000458s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 390510 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000409s ]