SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001189s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 526909 LIMIT 1 [ RunTime:0.000313s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 526909 [ RunTime:0.001792s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (505133,749600,350587,774526,898078,501842,429144,1010615,343122,353730,427420,847394,150769,161985,493267,976799,262509,488736,929374,979919,541471,557984,215984,961847,446238,444952,783100,945949,539027,894769,594683,318088,719600,847221,139130,650926,711366,954767,78433,762322,370069,154804,794938,774126,781379,653526,721529,671520,596061,51448,7617,114586,323105,1016013,18100,59713,903729,614641,314185,606729) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001002s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 526909 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000355s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 526909 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000927s ]