SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001147s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 534057 LIMIT 1 [ RunTime:0.000343s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 534057 [ RunTime:0.001534s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (654332,819854,469881,621453,1020288,985118,826640,421651,905594,193952,261832,22842,154078,187105,475091,798964,323420,26622,570875,464969,348351,531205,398005,198595,353266,164073,380850,528098,377757,630391,965142,430754,99075,914821,1039086,807861,233910,1047255,961990,413352,526359,1035893,600959,521776,353903,290543,617077,199236,769977,89913,32672,957518,427657,612016,47561,598582,392829,708220,12944,619322) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001371s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 534057 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000361s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 534057 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000621s ]