SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001149s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 506156 LIMIT 1 [ RunTime:0.000323s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 506156 [ RunTime:0.002133s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1014026,221989,384254,688201,716996,414208,344114,418121,669872,125755,757668,572727,266499,280472,916397,467723,104790,851012,329711,19074,162856,602373,635818,275438,83482,28183,202751,450907,823857,130137,53700,565627,16220,709180,367284,143836,339852,512226,397219,943389,597149,509684,1017090,782953,764356,174374,734538,863890,443149,615184,873353,181503,738093,71389,613174,725846,997979,1047352,277044,292998) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001049s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 506156 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000377s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 506156 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000471s ]