SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001118s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 982828 LIMIT 1 [ RunTime:0.000316s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 982828 [ RunTime:0.003143s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (565368,1043091,279426,215074,279834,21686,393434,375807,1045195,296109,860398,883432,1029096,996978,738110,462566,962754,561168,989478,509579,649015,45553,1035971,882650,203882,130408,700176,873795,512602,705090,477186,33856,584607,409320,303290,86530,119559,828891,142427,535239,242010,177542,591674,1005490,46692,937004,732450,909654,325563,372718,591909,188169,961017,720399,1034693,718885,75950,262461,430855,1043268) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000958s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 982828 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000343s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 982828 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000486s ]