SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001176s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 544294 LIMIT 1 [ RunTime:0.000346s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 544294 [ RunTime:0.002520s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (930888,80188,169798,690982,635650,508402,891179,753182,446804,912884,288469,797381,532422,149336,227273,1047759,466770,360764,428120,375569,499364,794894,649865,849005,686032,891239,924079,89167,12263,115230,447424,319861,139736,582509,438636,653856,996828,106480,657519,1023750,523825,867326,269030,99687,156316,699940,939231,303526,419237,550676,656506,156645,176771,285039,66130,887897,1007770,514223,268641,487076) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001278s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 544294 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000569s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 544294 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000652s ]