SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001831s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 413720 LIMIT 1 [ RunTime:0.000556s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 413720 [ RunTime:0.002967s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (156530,455721,713270,858262,130969,5605,1031790,847036,639413,875533,142164,868346,317863,508488,980061,956755,367114,652915,850794,806713,81289,595903,1016661,272604,1032028,777443,583349,94470,85039,869275,648162,366115,635534,524736,5391,242551,6115,15043,579232,810733,1027317,203784,101930,766727,58502,59408,144063,421078,787980,849808,425749,966545,256468,1041520,256567,249076,437591,397638,112983,63536) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001085s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 413720 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000415s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 413720 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000467s ]