SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001168s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1022596 LIMIT 1 [ RunTime:0.000592s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1022596 [ RunTime:0.001759s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (761634,1022368,721346,524199,615705,164105,1032573,1037550,923856,266012,501288,730928,745125,202932,591746,331470,124650,338909,100536,411371,85132,718533,132457,690420,794116,69083,395588,429682,611315,991192,217784,926555,342467,333525,457210,179141,12662,176229,750806,862455,1026669,408134,277224,374191,860953,369796,307656,781308,928576,531416,368116,256126,381450,317091,915522,513554,698218,887905,443950,11713) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001182s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1022596 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000439s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1022596 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000631s ]