SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001331s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 40568 LIMIT 1 [ RunTime:0.000430s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 40568 [ RunTime:0.001586s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (811811,50453,400389,807869,155471,989949,214595,257432,251726,645303,343735,615291,256577,247419,207259,763258,462689,224498,582534,172299,402360,101270,634268,8374,36193,274078,498517,453935,390274,938753,551764,430333,802319,573503,309579,913141,11113,175491,36751,569994,809895,996570,990579,480345,177676,405504,532460,413584,170282,734637,479842,145621,127999,862860,842769,733925,178538,882337,633014,560078) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001499s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 40568 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000382s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 40568 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000596s ]