SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001278s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 555322 LIMIT 1 [ RunTime:0.000333s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 555322 [ RunTime:0.001720s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (480684,833429,521660,376962,746079,132017,366515,101097,668704,364341,969184,249054,274487,1004559,995753,1046190,133432,856271,630128,967947,813348,893248,850068,1031208,31641,176867,635656,728269,222710,448498,3322,607009,611164,350060,503317,731471,195318,562125,193796,142625,525801,962215,727193,36314,463659,530574,548476,940613,339977,400809,222026,554701,986726,548452,671250,523887,437356,385755,400823,604554) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002161s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 555322 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000551s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 555322 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000433s ]