SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.004866s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 51353 LIMIT 1 [ RunTime:0.000670s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 51353 [ RunTime:0.003005s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (421324,85596,56694,340334,410332,620865,870898,148451,565466,800505,937916,419124,44741,791679,338186,443098,157961,773172,1022485,994531,322333,688752,544221,339253,981842,907047,637365,489898,994574,796277,412467,68163,990694,675019,266236,1006419,552219,927702,517864,731296,532710,871781,498361,197102,66162,131821,414269,689116,903926,1025938,874594,409657,901767,971535,11448,872217,897008,117071,660989,372897) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.008782s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 51353 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000433s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 51353 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000597s ]