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` = 555946 LIMIT 1 [ RunTime:0.000393s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 555946 [ RunTime:0.002357s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (642499,534836,48499,499773,189793,746789,512835,251730,711981,594429,374345,934603,230550,80847,16025,388055,326189,104952,731992,348305,326234,910681,552290,888369,499255,714463,129410,88538,465170,953265,979503,881603,1022133,384892,9645,482950,269397,681672,654690,524837,617126,349519,594374,697554,460506,868360,494944,541395,537252,296813,248786,434408,459256,352361,693929,637578,172828,617913,229248,447274) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000961s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 555946 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000342s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 555946 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000505s ]