SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001136s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 576491 LIMIT 1 [ RunTime:0.000324s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 576491 [ RunTime:0.001720s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (289088,1018992,923172,362693,738755,195928,489831,344197,812282,830697,1029345,415824,596165,26937,65794,698893,60541,154858,332305,555261,922544,886544,103923,809483,639724,712817,535655,789316,761904,592687,287516,979231,108318,328098,183933,1011919,178904,868122,134393,748318,991970,25430,624174,403564,1029000,602687,613976,862374,256475,360049,395949,1028422,482279,860720,506009,685648,70394,671980,713394,737232) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002214s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 576491 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000364s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 576491 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000376s ]