SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001199s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 319864 LIMIT 1 [ RunTime:0.000365s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 319864 [ RunTime:0.002409s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (975769,874416,637339,493654,78215,740552,363426,116255,519558,805084,870001,369824,141121,1022636,525204,582376,469343,221718,243890,523532,422877,717041,9180,965084,1019985,40187,102223,257099,729318,572607,336101,790528,879490,520474,103384,1044088,867047,1003223,681680,175499,559996,33354,175204,276030,647374,757262,296163,642110,751530,244427,48298,968159,481267,120090,1035451,504542,183133,703236,837678,678301) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001130s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 319864 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000360s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 319864 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001108s ]