SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001210s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 511922 LIMIT 1 [ RunTime:0.000439s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 511922 [ RunTime:0.003304s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1037218,375001,122948,115452,204369,216417,714380,18909,756335,787561,875421,873731,680020,595301,76420,8771,686853,987905,547464,938552,410385,958976,832164,689259,114749,268131,486432,854848,66617,683403,749244,987182,540506,726778,598292,308357,635683,450174,670007,430943,413175,949907,207432,53501,939155,69780,111933,665564,1041630,802657,479684,647236,392897,708372,495440,336062,71030,865294,639063,618008) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001254s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 511922 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000418s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 511922 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000622s ]