SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001120s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1022523 LIMIT 1 [ RunTime:0.000305s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1022523 [ RunTime:0.002055s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (681975,164204,752667,206884,608122,894623,444350,335064,46946,340697,744424,859436,866516,1016033,1206,178797,902169,69094,298590,891775,539131,496226,351484,865432,538911,98225,815869,553457,947826,280394,238083,525238,553541,240516,575330,563646,1039726,784014,812971,550619,707920,441398,370242,770333,630286,457528,498368,419418,928949,469236,367049,692609,495193,511891,319461,480944,206140,109823,979139,772064) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001141s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1022523 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.002798s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1022523 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000555s ]