SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001237s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 540039 LIMIT 1 [ RunTime:0.000596s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 540039 [ RunTime:0.001591s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (614550,488905,283222,708059,415713,1026174,646462,770984,386864,1035692,390703,221430,808721,883735,1034122,590479,104800,1043184,1015146,118190,667114,718455,219881,87891,181155,593459,511015,779974,378661,101808,283936,253296,179508,801990,263799,669250,899209,124769,414622,1031547,122848,592428,774421,814218,518438,154620,1021348,80460,946480,577104,488665,984838,521018,367206,757260,230562,228004,907154,455655,15157) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001126s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 540039 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000470s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 540039 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000597s ]