SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001150s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 150280 LIMIT 1 [ RunTime:0.000353s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 150280 [ RunTime:0.001718s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (883748,822656,321529,1039096,120825,791043,888979,3009,268045,312348,11423,1014172,148067,308103,648491,1019161,380532,435396,375437,309790,261941,992475,1020607,304368,23625,592487,884687,961155,1677,997613,693840,179531,604260,931811,65083,459993,11164,132526,268238,444021,167341,203331,859981,531672,798057,317069,987352,675938,700397,856301,69031,306491,326986,252574,1028447,101731,842856,760991,619982,25878) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000960s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 150280 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000510s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 150280 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000537s ]