SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.003930s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 457043 LIMIT 1 [ RunTime:0.000532s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 457043 [ RunTime:0.003360s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (136313,1020111,47268,68941,720192,754130,635736,702645,244326,132430,822949,55109,409122,756515,818547,398811,878236,148120,229696,62925,199923,230866,851558,422677,852968,383511,48081,193714,493334,946939,1040442,480116,690904,519774,518916,734945,499201,983070,503282,319000,297456,72841,938037,355234,559667,322396,771313,117842,743696,508043,119521,968537,212891,722763,4693,79932,433028,406365,845819,117634) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001039s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 457043 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000409s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 457043 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000572s ]