SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001246s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 394502 LIMIT 1 [ RunTime:0.000485s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 394502 [ RunTime:0.001720s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (725543,976986,931016,843917,261189,844765,370275,227708,589490,283715,1039682,499998,719796,130187,798080,562078,419460,751768,311448,1048117,864048,973374,830750,789987,502833,380587,163700,767658,819742,407434,779107,221900,53848,163376,1012256,325861,906432,937705,312520,815392,239446,377212,102676,886605,818888,189204,293180,533966,887614,189668,453347,1010567,457729,300181,1016112,869541,939337,16398,530073,239859) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001136s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 394502 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000453s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 394502 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000640s ]