SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001313s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 53993 LIMIT 1 [ RunTime:0.000422s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 53993 [ RunTime:0.002831s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1044567,459650,958656,210518,617500,518289,939988,202242,510785,587487,386005,540589,64852,272361,553625,354482,529705,730524,678110,10722,52942,536251,960327,258678,454186,649122,914908,872477,251025,866631,610301,1012715,141100,986545,1040618,288218,879363,224113,384820,196100,398000,585239,506105,1035060,210765,745910,913515,73642,415380,894345,779592,172796,1041962,378005,442917,790974,77431,299016,581811,561303) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001032s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 53993 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000348s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 53993 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000605s ]