SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001251s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 521051 LIMIT 1 [ RunTime:0.000362s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 521051 [ RunTime:0.001609s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (398250,747008,841358,418931,445772,883664,452587,930694,764589,698809,723288,748020,1038522,847889,870136,280748,1039543,1030173,11414,17633,790026,871884,845496,309782,846472,545589,6425,629794,248585,470644,180199,801318,886296,783876,1008405,842502,318453,809502,847574,225004,453709,540437,3914,311582,21202,534664,142220,711089,61954,119905,813098,777927,909595,341575,788113,154372,39268,35827,371446,583457) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001204s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 521051 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000506s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 521051 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000479s ]