SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001149s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 51121 LIMIT 1 [ RunTime:0.000379s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 51121 [ RunTime:0.001481s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (788136,410935,728336,383448,788465,284621,547707,161820,190949,628327,94979,840072,281493,731796,745582,721342,412871,253985,784588,70466,110605,91243,264161,364782,454473,396438,809285,65818,700234,29867,373285,519825,469872,255346,869411,790951,123969,322469,600535,641865,1003698,729724,817121,630786,879647,418451,169587,856797,189874,231363,1004181,181074,276435,229737,991738,380892,43252,253425,229630,353239) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.003146s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 51121 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000848s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 51121 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000847s ]