SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001140s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 407832 LIMIT 1 [ RunTime:0.000326s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 407832 [ RunTime:0.001728s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (487752,143116,700011,281984,176520,15160,456081,488401,645599,677155,5895,998714,774694,201970,237081,288577,682973,359486,11011,818674,401107,52014,331569,244779,574707,582510,416069,646272,399169,495266,968099,452643,713207,532318,821544,774864,640141,974232,445128,362025,124493,544369,947940,627209,565209,858634,789782,1035224,365899,462322,179770,326190,983165,757992,368538,273340,596552,900920,291212,776137) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000971s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 407832 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000339s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 407832 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000543s ]