SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001356s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 501071 LIMIT 1 [ RunTime:0.000522s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 501071 [ RunTime:0.001972s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (634815,615443,816912,193864,519560,65562,106911,1026674,949380,1002451,395327,172751,927937,245033,445151,693658,942539,545467,748017,906717,964694,93368,203237,589277,654580,526287,666631,588481,16327,742354,136685,658412,763217,3757,150107,241942,634291,525893,101989,941719,225201,605894,290138,807198,940336,192825,2724,457690,741823,486637,644743,218121,452744,342730,713641,439581,642325,1012940,959855,120438) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001525s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 501071 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000467s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 501071 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000641s ]