SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001148s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 476451 LIMIT 1 [ RunTime:0.000968s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 476451 [ RunTime:0.001746s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (462536,878459,650260,970811,713859,29042,1006205,682892,163499,239171,511774,356498,1032778,388569,361088,231818,1015308,430364,843543,459182,420599,6639,768619,797060,157361,98748,622664,757634,265740,591197,791602,707368,27396,542252,96512,1809,238697,750326,972734,278897,333749,875147,726235,458020,577356,631231,517177,733104,497258,85590,189965,68140,38426,260710,51829,677295,825681,679565,974924,9010) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001135s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 476451 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000374s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 476451 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000542s ]