SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001228s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 498088 LIMIT 1 [ RunTime:0.000382s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 498088 [ RunTime:0.001396s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (318691,105172,205137,832920,43798,689933,617743,224401,47291,219154,226884,552232,768535,407297,883904,551396,1048803,254683,306732,184077,417076,1022896,998541,36564,97869,121112,1042379,1001286,569015,373679,100471,851871,1018780,210812,951872,33193,84862,384263,596463,561078,707059,774763,595543,1014574,404795,163758,875576,109429,1008104,185107,93187,188420,698570,551449,115595,672627,826007,585309,532351,474746) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001017s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 498088 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000353s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 498088 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000534s ]