SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001130s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 972918 LIMIT 1 [ RunTime:0.000339s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 972918 [ RunTime:0.002011s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1024778,243798,1018336,768939,814660,640460,467413,934551,363979,121365,865849,727638,43677,794753,32460,929877,110888,989046,930220,550931,456266,826201,679414,422366,377511,580903,986772,127017,719847,90788,284142,763396,809244,785000,489597,830536,509055,118592,252935,771669,1041692,261858,461741,509822,156755,798500,774046,709149,737708,598376,170539,642713,110113,800695,364787,633902,441806,595924,35470,578729) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000992s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 972918 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000327s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 972918 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000562s ]