SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001211s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 532212 LIMIT 1 [ RunTime:0.000295s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 532212 [ RunTime:0.001654s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (670441,702517,854391,847186,746253,537052,745458,445158,898401,120035,434095,968697,558465,572681,515829,863751,233619,1011846,310881,954500,662689,715174,924808,437180,227179,75880,496052,311965,795560,166358,56459,166226,656921,37671,934345,368557,699927,399275,89814,615706,603685,457750,879648,245632,273719,683041,215346,785336,504756,937598,741924,479917,119295,660763,278327,386318,434205,350979,648119,977329) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001065s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 532212 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000377s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 532212 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000566s ]