SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001141s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 542301 LIMIT 1 [ RunTime:0.000301s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 542301 [ RunTime:0.001838s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (405554,185415,978953,500047,840152,77300,761218,498566,982996,121342,570294,875589,26711,830029,167458,556533,143511,757979,234178,165089,647588,850750,1019458,725734,511222,588472,93253,166281,887096,178042,608860,387429,408189,350315,201319,91425,351813,633488,55976,106690,971009,981221,407957,261422,597904,272277,228323,336613,598981,677433,889988,556956,141367,536530,679853,746481,699646,373883,393794,218166) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000971s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 542301 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000339s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 542301 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000483s ]