SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001152s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1012603 LIMIT 1 [ RunTime:0.000300s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1012603 [ RunTime:0.001934s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (450466,101403,812499,685270,716318,569568,282551,529930,12264,636579,652101,714286,76318,413023,500325,604821,827312,80745,965084,748054,834714,997502,525475,742371,606752,194043,565638,1002920,329280,250324,286619,767047,150663,1038236,892949,91431,850094,4639,853386,638069,100701,867780,818862,245032,224177,1007507,923557,310921,300456,437378,788411,105186,43413,30797,688436,907124,659392,853908,270618,723511) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001087s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1012603 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000337s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1012603 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000509s ]