SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.000991s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1042861 LIMIT 1 [ RunTime:0.000350s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1042861 [ RunTime:0.001460s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (742148,726577,263271,12135,827155,28637,885154,875737,326996,872993,676260,949232,69375,166106,158505,487100,797142,338165,162558,730308,708206,705225,983526,52555,614535,293329,13462,433286,395552,530771,148762,527319,792883,708426,228117,587440,406152,829339,711478,264936,797394,958123,658959,978460,114261,405064,529623,381070,993927,145357,982845,230713,373682,71059,140452,414728,531782,796132,933746,341430) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001094s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1042861 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000369s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1042861 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000440s ]