SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001208s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 583670 LIMIT 1 [ RunTime:0.000425s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 583670 [ RunTime:0.002246s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (514542,56805,148583,353246,985115,892139,708996,636114,691142,51688,516391,285266,587228,507109,214421,962158,983328,69161,330052,761333,158791,519829,85227,44233,318340,366510,129189,120726,123839,781369,280611,147622,53282,443122,261506,163069,440778,676586,964140,267593,631914,306909,290650,997697,800028,538212,154547,598958,925846,442558,297971,575841,52847,813837,726493,770154,2593,125740,572005,331409) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000949s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 583670 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000329s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 583670 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000529s ]