SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001282s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 557814 LIMIT 1 [ RunTime:0.000337s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 557814 [ RunTime:0.001800s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1003726,1012019,472522,164927,723528,80277,577969,627554,886508,910270,1006583,787878,555679,74799,901406,816458,1038897,688048,583739,488405,90787,526159,942158,734341,333273,1036469,609426,865099,412801,407069,519050,406694,50993,181195,30291,13575,758550,845126,73142,456979,486796,76099,483742,813777,181280,220586,797415,976011,777162,1030422,125161,894268,1014193,861394,573537,36192,459570,84537,735040,940002) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002228s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 557814 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000377s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 557814 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000630s ]